package com.team.dao;

import com.team.entity.Dept;
import com.team.entity.Section;
import com.team.vo.StatisticalVo;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface SectionMapper {
    int deleteByPrimaryKey(Integer id);
    //添加科室的信息
    int insert(Section record);

    int insertSelective(Section record);

    Section selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Section record);
    //修改科室
    int updateByPrimaryKey(Section record);

    //查询所有的科室
    List<Section> queryAllSelect(@Param("name") String name, @Param("status") Integer status);


    /**
     * 查询所有部门
     * @return
     */
    List<Dept> selectAllid();
    List<Section> selectAllByDeptSections(Integer id);

    List<Section> selectByAccount(String account);

    List<Section> selectAllByDeptId(Integer id);

    List<Section> selectAllName();
}